﻿/********************************************************************************** 
     * 开发人:邱慕夏
     * 开发组： 
     * 类说明：  
     * 开发时间：2015/11/23 14:12:19 
     *开发版本：V1.0
 **********************************************************************************/

using Model;
using DAL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace BLL
{
    public class StudentBindPaperTypeBLL
    {
        private StudentBindPaperTypeDAL studentBindPaperTypeDAL;
        public StudentBindPaperTypeBLL()
        {
            studentBindPaperTypeDAL = new StudentBindPaperTypeDAL();
        }

        #region 根据学生的ID抽提的时候进行查询的sql语句---邱慕夏--2015年11月22日
        /// <summary>
        /// 根据学生的ID抽提的时候进行查询的sql语句---邱慕夏--2015年11月22日
        /// </summary>
        /// <param name="studentinfo">学生的ID</param>
        /// <returns></returns>
        public DataTable SelectAllMajor(String studentID)
        {
            return studentBindPaperTypeDAL.SelectAllMajor(studentID);
        }
        #endregion


        #region insert---邱慕夏--2015年11月22日
        /// <summary>
        /// insert--邱慕夏
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>是否添加成功</returns>
        public int InsertRecord(StudentBindPaperTypeEntity studentBindPaperType)
        {
            return studentBindPaperTypeDAL.InsertRecord(studentBindPaperType);
        }
        #endregion

        #region 根据学生的ID去重---邱慕夏--2015年11月22日
        /// <summary>
        /// select--邱慕夏
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>是否已经存在</returns>
        public Boolean SelectRecord(StudentBindPaperTypeEntity studentBindPaperType)
        {
            return studentBindPaperTypeDAL.SelectRecord(studentBindPaperType);
        }
        #endregion

        #region 批量insert---邱慕夏--2015年11月22日
        /// <summary>
        /// insert--邱慕夏
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>是否添加成功</returns>
        public int InsertRecordList(List<StudentBindPaperTypeEntity> studentBindPaperTypeList)
        {
            return studentBindPaperTypeDAL.InsertRecordList(studentBindPaperTypeList);
        }
        #endregion

        #region 根据时间戳查询在考人数---赵寒--2016年1月4日08:35:52
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>在考人数</returns>
        public DataTable OnLineCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.OnLineCount(studentBindPaperType,timeEntity);
        }
        #endregion

        #region 根据时间戳查询本场总考生人数---吕德彪--2018
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>在考人数</returns>
        public DataTable AllCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.AllCount(studentBindPaperType, timeEntity);
        }
        #endregion


        #region 根据时间戳查询该考场在线考生人数---吕德彪--2018
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>该考场在线考生人数</returns>
        public DataTable ExamPlaceOnlineCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity, string strPlace)
        {
            return studentBindPaperTypeDAL.ExamPlaceOnlineCount(studentBindPaperType, timeEntity, strPlace);
        }
        #endregion

        #region 根据时间戳查询该考场总考生人数---吕德彪--2018
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>在考人数</returns>
        public DataTable ExamPlaceCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity, string strPlace)
        {
            return studentBindPaperTypeDAL.ExamPlaceCount(studentBindPaperType, timeEntity, strPlace);
        }
        #endregion


        #region 根据时间戳查询该考场已交卷考生人数---吕德彪--2018
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>该考场已交卷考生人数</returns>
        public DataTable SubmittedCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity, string strPlace)
        {
            return studentBindPaperTypeDAL.SubmittedCount(studentBindPaperType, timeEntity, strPlace);
        }
        #endregion

        #region 根据时间戳查询该考场文件未上传成功考生人数---吕德彪--2018
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>该考场文件未上传成功考生人数</returns>
        public DataTable UnUploadCount(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity, string strPlace)
        {
            return studentBindPaperTypeDAL.UnUploadCount(studentBindPaperType, timeEntity, strPlace);
        }
        #endregion

        #region 根据时间戳查询未交卷学生---赵寒--2016年1月4日08:35:52
        /// <summary>
        /// insert--赵寒
        /// </summary>
        /// <param name="studentinfo"></param>
        /// <returns>在考人数</returns>
        public DataTable OnLineStudent(StudentBindPaperTypeEntity studentBindPaperType)
        {
            return studentBindPaperTypeDAL.OnLineStudent(studentBindPaperType);
        }
        #endregion

        #region 根据考场查询在考人-赵寒-2016年1月10日19:23:18

        public DataTable OnLineStudentbyPlace(StudentBindPaperTypeEntity studentbindpapertype, string strPlace)
        {
            return studentBindPaperTypeDAL.OnLineStudentbyPlace(studentbindpapertype, strPlace);
        }
        
        #endregion

        #region 二次登陆，更新 binding表中的 IP -2016年1月8日14:42:30
        /// <summary>
        /// 二次登陆，更新 binding表中的 IP
        /// </summary>
        /// <param name="studentBindPaperTypeEntity"></param>
        public void updateLoginIP(StudentBindPaperTypeEntity studentBindPaperTypeEntity)
        {
            studentBindPaperTypeDAL.updateLoginIP(studentBindPaperTypeEntity);
        }
        #endregion

        #region 查询所有考生的信息
        public DataTable GetPalces(string startTime, string endTime,string Sore)
        {
           return  studentBindPaperTypeDAL.GetPlaces(startTime, endTime,Sore);
        }
        #endregion

        #region  查询所有学生的总分数
        public DataTable GetScore()
        {
            return studentBindPaperTypeDAL.GetScore();
        }
        #endregion

        #region 查询所有再考学生_吕德彪
        /// <summary>
        /// 查询所有再考学生_吕德彪
        /// </summary>
        /// <returns></returns>
        public DataTable AllOnlineStudent(StudentBindPaperTypeEntity studentBindPaperType)
        {
            return studentBindPaperTypeDAL.AllOnlineStudent(studentBindPaperType);
        }
        #endregion

        #region 按考场和时间查询再考学生_吕德彪
        /// <summary>
        /// 按考场和时间查询再考学生
        /// </summary>
        /// <param name="studentBindPaperType"></param>
        /// <param name="strPlace"></param>
        /// <returns></returns>
        public DataTable OnLineStudentBy(StudentBindPaperTypeEntity studentBindPaperType, string strPlace,TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.OnLineStudentBy(studentBindPaperType, strPlace,timeEntity);
        }
        #endregion

        #region 模糊查询为交卷学校-吕德彪
        /// <summary>
        /// 模糊查询为交卷学校
        /// </summary>
        /// <param name="studentBindPaperType"></param>
        /// <param name="studentInfo"></param>
        /// <param name="college"></param>
        /// <returns>模糊查询为交卷学校</returns>
        public DataTable NotSubmitStudent( TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.NotSubmitStudent(timeEntity);
        }
        #endregion

        #region 查询在时间段内的所有学生
        /// <summary>
        /// 查询在时间段内的所有学生
        /// </summary>
        /// <param name="studentBindPaperType"></param>
        /// <param name="timeEntity"></param>
        /// <returns></returns>
        public DataTable AllStudent(StudentBindPaperTypeEntity studentBindPaperType, TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.AllStudent(studentBindPaperType,timeEntity);
        }
        #endregion

        #region 查询各考场的所有学生
        /// <summary>
        /// 查询各考场的所有学生
        /// </summary>
        /// <param name="studentBindPaperType"></param>
        /// <param name="strPlace"></param>
        /// <param name="timeEntity"></param>
        /// <returns></returns>
        public DataTable PlaceAllStudent(StudentBindPaperTypeEntity studentBindPaperType, string strPlace, TimeEntity timeEntity)
        {
            return studentBindPaperTypeDAL.PlaceAllStudent(studentBindPaperType,strPlace,timeEntity);
        }
        #endregion

        #region 根据学号查询绑定表-吕德彪
        /// <summary>
        /// 根据学号查询绑定表-吕德彪
        /// </summary>
        /// <param name="studentID"></param>
        /// <returns></returns>
        public DataTable SelectByStudentID(string studentID)
        {
            return studentBindPaperTypeDAL.SelectByStudentID(studentID);
        }
        #endregion
    }
}
